The Query Options, found on the Query ribbon in Discover Pro, allow users to make subtle adjustments to how the query engine works throughout the application. These settings are applied each time a query is executed per report.
Query Ribbon
The Query options are available in the Query ribbon:
Note: The preceding options are only enabled on the user interface if they are valid for selection given your current data source. For more information, see below.
Query Settings
The Query Settings drop-down offers a variety of settings that drive the way queries operate. It includes:
- Cache options - Whether the query results are returned from the cache, or the query is run every time.
- Row limit - The maximum number of rows to return in the query results.
- Optimization settings - The settings that modulate query construction. Note: Depending on your data source, this may include total settings, sub-querying, and so on.
Important: Optimization Settings are available on Microsoft Multidimensional and Tabular, SAP BW models and cubes, and SQL relational databases. Note: Which sub-options are available depends on your data source.
Choose Language
The Choose Language drop-down allows you to select the language that the model metadata and query results should be presented in, irrespective of the application's current language.
Model Colors and Formats
The Model Colors and Formats drop-down indicates whether model-defined data colors and value formats are returned in queries and drawn in the visualized results.
Important: This option is only available on Microsoft Multidimensional and Tabular.
Default Query Options
Your administrator can set default Query Options using the User Defaults capability in the Admin Console. If necessary, you can override their selection in your personal User Defaults, which can be set in Discover or the System Info panel.